1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 namespace SoftQuanLyNhaHang.Controllers
11 {
12 class BanHangCtrl
13 {
14 // Method Add
15 public static int InsertBanHang(int _idBanHang, string _maSanPham, string _tenSanPham, double _giaBan, double _thanhTien, float _soLuong, string _donViTinh, int _donViTinhId, int _khachHangId, DateTime _ngayMuaHang, int _trangThai, int _nhapKhoId, double _chietKhauPhanTram, double _thue, float _soLuongDaBan)
16 {
17 try
18 {
19 Models.BanHangMod _banHang = new Models.BanHangMod(_idBanHang, _maSanPham, _tenSanPham, _giaBan, _thanhTien, _soLuong, _donViTinh, _donViTinhId, _khachHangId, _ngayMuaHang, _trangThai, _nhapKhoId, _chietKhauPhanTram, _thue, _soLuongDaBan);
20 return _banHang.InsertBanHang();
21 }
22 catch
23 {
24 return 0;
25 }
26 }
27
28 // Method Update
29 public static int UpdateBanHang(int _idBanHang, string _maSanPham, string _tenSanPham, double _giaBan, double _thanhTien, float _soLuong, string _donViTinh, int _donViTinhId, int _khachHangId, DateTime _ngayMuaHang, int _trangThai, int _nhapKhoId, double _chietKhauPhanTram, double _thue, float _soLuongDaBan)
30 {
31 try
32 {
33 Models.BanHangMod _banHang = new Models.BanHangMod(_idBanHang, _maSanPham, _tenSanPham, _giaBan, _thanhTien, _soLuong, _donViTinh, _donViTinhId, _khachHangId, _ngayMuaHang, _trangThai, _nhapKhoId, _chietKhauPhanTram, _thue, _soLuongDaBan);
34 return _banHang.UpdateBanHang();
35 }
36 catch
37 {
38 return 0;
39 }
40
41 }
42
43 //update thue, chiet khau
44 public static int UpdateBanHang_Thue_ChietKhau(int _idBanHang, double _chietKhauPhanTram, double _thue, double _thanhTien)
45 {
46 try
47 {
48 Models.BanHangMod _banHang = new Models.BanHangMod(_idBanHang, _chietKhauPhanTram, _thue, _thanhTien);
49 return _banHang.UpdateBanHang_Thue_ChietKhau();
50 }
51 catch
52 {
53 return 0;
54 }
55 }
56
57 //update trang thai
58 public static int UpdateBanHang_TrangThai(string _maSanPham, int _idKhachHang, int _trangThai)
59 {
60 try
61 {
62 Models.BanHangMod _banHang = new Models.BanHangMod( _maSanPham, _idKhachHang, _trangThai);
63 return _banHang.UpdateBanHang_TrangThai();
64 }
65 catch
66 {
67 return 0;
68 }
69 }
70
71
72 // Method Delete
73 public static int DeleteBanHang(int _idBanHang)
74 {
75 try
76 {
77 Models.BanHangMod _banHang = new Models.BanHangMod(_idBanHang);
78 return _banHang.DeleteBanHang();
79 }
80 catch
81 {
82 return 0;
83 }
84
85 }
86
87 public static DataSet FillDataSet_getBanHangByKhachHangId(string _maSanPham, int _idKhachHang)
88 {
89 try
90 {
91 Models.BanHangMod sp = new Models.BanHangMod(_maSanPham, _idKhachHang);
92 return sp.FillDataSet_getBanHangByKhachHangId();
93
94 }
95 catch
96 {
97 return null;
98 }
99 }
100
101 //Lấy sản phẩm mua hàng
102 public static DataSet FillDataSet_getBanHangByKhachHangId_MuaHang(string _maSanPham, int _idKhachHang, int _trangThai)
103 {
104 try
105 {
106 Models.BanHangMod sp = new Models.BanHangMod(_maSanPham, _idKhachHang, _trangThai);
107 return sp.FillDataSet_getBanHangByKhachHangId_MuaHang();
108
109 }
110 catch
111 {
112 return null;
113 }
114 }
115
116 public static DataSet FillDataSet_getBanHangByKhachHangId_MuaHang2(string _maSanPham, int _idKhachHang, int _trangThai, int _nhapKhoId)
117 {
118 try
119 {
120 Models.BanHangMod sp = new Models.BanHangMod(_maSanPham, _idKhachHang, _trangThai, _nhapKhoId);
121 return sp.FillDataSet_getBanHangByKhachHangId_MuaHang2();
122
123 }
124 catch
125 {
126 return null;
127 }
128 }
129
130
131 // update custom bang ban hang
132 public static int Update_BanHang_Update_SL_Gia(int _idBanHang, string _tenSanPham, double _giaBan, double _thanhTien, float _soLuong, float _soLuongDaBan)
133 {
134 try
135 {
136 Models.BanHangMod _banHang = new Models.BanHangMod(_idBanHang, _tenSanPham, _giaBan, _thanhTien, _soLuong, _soLuongDaBan);
137 return _banHang.Update_BanHang_Update_SL_Gia();
138 }
139 catch
140 {
141 return 0;
142 }
143
144 }
145
146 //update gia khuyen mai
147 public static int Update_BanHang_Update_GiaKhuyenMai(int _idBanHang, double _giaBan)
148 {
149 try
150 {
151 Models.BanHangMod _banHang = new Models.BanHangMod(_idBanHang, _giaBan);
152 return _banHang.Update_BanHang_Update_GiaKhuyenMai();
153 }
154 catch
155 {
156 return 0;
157 }
158
159 }
160 //danh sach ban hang
161 //lay danh sach khach hang
162 public static DataSet FillDataSet_BanHang_BySearch(int _idBanHang, string _maSanPham, string _tenSanPham, double _giaBan, double _thanhTien, float _soLuong, string _donViTinh, int _donViTinhId, int _khachHangId, DateTime _ngayMuaHang, int _trangThai, int _nhapKhoId, double _chietKhauPhanTram, double _thue,DateTime _tuNgay, int _PageSize, int _PageIndex)
163 {
164 try
165 {
166 Models.BanHangMod sp = new Models.BanHangMod(_idBanHang, _maSanPham, _tenSanPham, _giaBan, _thanhTien, _soLuong, _donViTinh, _donViTinhId, _khachHangId, _ngayMuaHang, _trangThai, _nhapKhoId, _chietKhauPhanTram, _thue,_tuNgay, _PageSize, _PageIndex);
167 return sp.FillDataSet_BanHang_BySearch();
168 }
169 catch
170 {
171 return null;
172 }
173 }
174
175 //dem tong mat hang
176 //
177 public static DataSet FillDataSet_BanHang_CountMatHang_byKhachHangId(string _maSanPham, int _khachHangId, int _trangThai, DateTime _ngayMuaHang)
178 {
179 try
180 {
181 Models.BanHangMod sp = new Models.BanHangMod(_maSanPham, _khachHangId, _trangThai,_ngayMuaHang );
182 return sp.FillDataSet_BanHang_CountMatHang_byKhachHangId();
183 }
184 catch
185 {
186 return null;
187 }
188 }
189 }
190 }